<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" ignoreFilterContext="true" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 17:16:42--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;quot; to &amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;quot; at 2015-6-25. 2:12:34--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;amp;amp;quot; to &amp;amp;amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;amp;amp;quot; at 2014-9-16. 6:39:43-->

				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>

				

				

				<layouts>

					<layout>

						<reportPages>

							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles><CSS value="width:1180px"/></style>

								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles><CSS value="text-align:left;font-family:Helvetica"/></style>

									<contents>

										

									<HTMLItem>

			<dataSource>

				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>

			</dataSource>

		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1250px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Cost Forecast and Breakdown</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Current Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Current Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Current Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Projected Cost</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Base Forecast and Cost">
			<contents><textItem><dataSource><dataItemValue refDataItem="Projected Cost"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Usable Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Current Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Current Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Allocated Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Current Capacity">
			<contents><textItem><dataSource><dataItemValue refDataItem="volTB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Trending Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Description)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Report">

																				<v2_combinationTypeTooltips/>

																				<v2_commonAxis>

																					<v2_ordinalAxis>

																						

																						<v2_axisLabels>

																							<style>

																								<defaultStyles>

																									<defaultStyle refStyle="al"/>

																								</defaultStyles>

																							<CSS value="color:#454545"/></style>

																						</v2_axisLabels>

																						</v2_ordinalAxis>

																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Month"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>

																				<v2_topLeftAxis>

																					<v2_combinationChartTypes>

																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers">

																							<v2_linePalette markerSize="5pt">

																		<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px" lineStyle="dash_dot"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Historical Cost"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Historical Cost"/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Future Cost"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Future Cost"/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>

																					</v2_combinationChartTypes>

																					<v2_axis>

																						

																						<v2_axisRange>

																							<v2_automaticRange includeZeroForAutoScale="false"/>

																						</v2_axisRange>

																						<v2_axisLabels>

																	<style>

																		<defaultStyles>

																			<defaultStyle refStyle="al"/>

																		</defaultStyles>

																		<dataFormat><currencyFormat decimalSize="0"/></dataFormat><CSS value="color:#454545"/></style>

																</v2_axisLabels><v2_majorGridlines lineColor="#F0F0F0" lineWeight="0"/></v2_axis>

																				</v2_topLeftAxis>

																				<style>

																					<CSS value="width:590px;height:180px;font-family:Arial;color:#333333"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>

																				<noDataHandler>

																					<contents>

																						<block>

																							<contents>

																								<textItem>

																									<dataSource>

																										<staticValue>No Data Available</staticValue>

																									</dataSource>

																									<style>

																										<CSS value="padding:10px 18px;"/>

																									</style>

																								</textItem>

																							</contents>

																						</block>

																					</contents>

																				</noDataHandler>

																				<v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend><XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 5 Costly Arrays</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Description)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart matchSeriesColor="true" maxHotspots="10000" name="Combination Chart2" orientation="horizontal" refQuery="Top 5 Arrays" depth="9">
																						<v2_combinationTypeTooltips/>
																						
																						<v2_commonAxis>
																							<v2_ordinalAxis>
																								<v2_axisLabels>
																									<style>
																										<defaultStyles>
																											<defaultStyle refStyle="al"/>
																										</defaultStyles>
																									<CSS value="color:#454545"/></style>
																								</v2_axisLabels>
																								<v2_axisLine lineColor="#CCCCCC" majorTickMarkLocation="none"/><v2_majorGridlines lineColor="white" lineWeight="0"/></v2_ordinalAxis>
																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Cost of Storage"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																						<v2_topLeftAxis>
																							<v2_combinationChartTypes>
																								<v2_bar barShape="box">
																									<v2_solidPalette>
																										<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																									<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Cost of Storage"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><currencyFormat decimalSize="0" pattern=" $#,###,###.## M" scale="-6"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels labelCollisionMode="fine_stagger"/></v2_bar>
																							</v2_combinationChartTypes>
																							<v2_axis>
																								
																								<v2_axisRange>
																									<v2_automaticRange/>
																								</v2_axisRange>
																								</v2_axis>
																						</v2_topLeftAxis>
																						<style>
																							<CSS value="width:590px;height:180px;font-family:Arial;color:#333333"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
																						<noDataHandler>
																							<contents>
																								<block>
																									<contents>
																										<textItem>
																											<dataSource>
																												<staticValue>No Data Available</staticValue>
																											</dataSource>
																											<style>
																												<CSS value="padding:10px 18px;"/>
																											</style>
																										</textItem>
																									</contents>
																								</block>
																							</contents>
																						</noDataHandler>
																						<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Data Center Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Pie Chart3" orientation="horizontal" refQuery="Current Capacity" depth="9">
																						<v2_combinationTypeTooltips/>
																						
																						<v2_commonAxis>
																							<v2_ordinalAxis>
																								
																								
																								<v2_axisLabels>
																									<style>
																										<defaultStyles>
																											<defaultStyle refStyle="al"/>
																										</defaultStyles>
																									</style>
																								</v2_axisLabels>
																							</v2_ordinalAxis>
																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Data Center"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																						<v2_topLeftAxis>
																							<v2_combinationChartTypes>
																								<v2_bar barShape="box">
																									<v2_solidPalette>
																										<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																									<v2_chartDataLabels/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Current Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,###.## M"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																							</v2_combinationChartTypes>
																							<v2_axis>
																								
																								
																								<v2_axisRange>
																									<v2_automaticRange/>
																								</v2_axisRange>
																								
																								
																								
																							</v2_axis>
																						</v2_topLeftAxis>
																						<style>
																							<CSS value="width:385px;height:180px;font-family:Arial;color:#333333"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
																						<noDataHandler>
																							<contents>
																								<block>
																									<contents>
																										<textItem>
																											<dataSource>
																												<staticValue>No Data Available</staticValue>
																											</dataSource>
																											<style>
																												<CSS value="padding:10px 18px;"/>
																											</style>
																										</textItem>
																									</contents>
																								</block>
																							</contents>
																						</noDataHandler>
																						<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Tier Cost</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Pie Chart2" orientation="horizontal" refQuery="Latest" depth="9">
																						<v2_combinationTypeTooltips/>
																						
																						<v2_commonAxis>
																							<v2_ordinalAxis>
																								
																								
																								<v2_axisLabels>
																									<style>
																										<defaultStyles>
																											<defaultStyle refStyle="al"/>
																										</defaultStyles>
																									</style>
																								</v2_axisLabels>
																							</v2_ordinalAxis>
																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Tier Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																						<v2_topLeftAxis>
																							<v2_combinationChartTypes>
																								<v2_bar barShape="box">
																									<v2_solidPalette>
																										<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																									<v2_chartDataLabels labelCollisionMode="fine_stagger"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Historical Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Historical Cost"/></sortList><style><dataFormat><currencyFormat pattern=" $#,###,###.## M" scale="-6"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																							</v2_combinationChartTypes>
																							<v2_axis>
																								
																								
																								<v2_axisRange>
																									<v2_automaticRange/>
																								</v2_axisRange>
																								
																								
																								
																							</v2_axis>
																						</v2_topLeftAxis>
																						<style>
																							<CSS value="width:385px;height:180px;font-family:Arial;color:#333333"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
																						<noDataHandler>
																							<contents>
																								<block>
																									<contents>
																										<textItem>
																											<dataSource>
																												<staticValue>No Data Available</staticValue>
																											</dataSource>
																											<style>
																												<CSS value="padding:10px 18px;"/>
																											</style>
																										</textItem>
																									</contents>
																								</block>
																							</contents>
																						</noDataHandler>
																						<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Vendor Costs</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Pie Chart1" orientation="horizontal" refQuery="Top 5 Arrays1" depth="9">
																						<v2_combinationTypeTooltips/>
																						
																						<v2_commonAxis>
																							<v2_ordinalAxis>
																								
																								
																								<v2_axisLabels>
																									<style>
																										<defaultStyles>
																											<defaultStyle refStyle="al"/>
																										</defaultStyles>
																									</style>
																								</v2_axisLabels>
																							</v2_ordinalAxis>
																						<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Manufacturer"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																						<v2_topLeftAxis>
																							<v2_combinationChartTypes>
																								<v2_bar barShape="box">
																									<v2_solidPalette>
																										<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																									<v2_chartDataLabels labelCollisionMode="fine_stagger"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Cost of Storage"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total Cost of Storage"/></sortList><style><dataFormat><currencyFormat decimalSize="2" pattern=" $#,###,###.## M" scale="-6"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																							</v2_combinationChartTypes>
																							<v2_axis>
																								
																								
																								<v2_axisRange>
																									<v2_automaticRange/>
																								</v2_axisRange>
																								
																								
																								
																							</v2_axis>
																						</v2_topLeftAxis>
																						<style>
																							<CSS value="width:385px;height:180px;font-family:Arial;color:#333333"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><generatedBackground><fill><fillColor color="white"/></fill></generatedBackground></style>
																						<noDataHandler>
																							<contents>
																								<block>
																									<contents>
																										<textItem>
																											<dataSource>
																												<staticValue>No Data Available</staticValue>
																											</dataSource>
																											<style>
																												<CSS value="padding:10px 18px;"/>
																											</style>
																										</textItem>
																									</contents>
																								</block>
																							</contents>
																						</noDataHandler>
																						<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Cost Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Capacity List Cost" rowsPerPage="5000">

			

			

			

			<noDataHandler>

				<contents>

					<block>

						<contents>

							<textItem>

								<dataSource>

									<staticValue>No Data Available</staticValue>

								</dataSource>

								<style>

									<CSS value="padding:10px 18px;"/>

								</style>

							</textItem>

						</contents>

					</block>

				</contents>

			</noDataHandler>

			<style>

				<CSS value="border-collapse:collapse;width:100%;font-family:Arial"/>

				<defaultStyles>

					<defaultStyle refStyle="ls"/>

				</defaultStyles>

			</style>

		<listColumns><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Center"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;color:#333333;font-weight:normal;border-bottom-style:none;font-family:Helvetica;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Center"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Manufacturer"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Manufacturer"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Model"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Model"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Serial Number"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cost / GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="background-image:none;border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;text-align:left;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cost / GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Raw Capacity (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;text-align:left;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Raw Capacity (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><CSS value="font-family:Arial;height:20px;text-align:left;padding-left:5px;font-weight:bold;color:rgb(158,162,162);border:1px solid #E2E2E1"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Cost of Storage"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><currencyFormat/></dataFormat><CSS value="background-image:none;border-top-style:none;background-color:white;border-bottom-style:none;font-family:Helvetica;text-align:left;color:#333333;border-left:1px none silver;border-right:1px none silver"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Cost of Storage"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>

								</pageBody>

								

								<pageFooter>

									<contents>

										

									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>

									<style>

										<defaultStyles>

											<defaultStyle refStyle="pf"/>

										</defaultStyles>

										<CSS value="padding-top:10px"/>

									</style>

								</pageFooter>

							<pageSetup/></page>

						</reportPages>

					</layout>

				</layouts>

			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>5.3 Cost Forecast and Breakdown</reportName><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 13"><styleCases><styleCase><style><CSS value="background-color:red;color:black;font-weight:bold"/></style><reportCondition>([Report].[Projected Used Capacity (GB)]/[Report].[Projected Capacity (GB)])&gt;=1</reportCondition></styleCase><styleCase><style><CSS value="background-color:yellow;color:black;font-weight:bold"/></style><reportCondition>([Report].[Projected Used Capacity (GB)]/[Report].[Projected Capacity (GB)])&gt;=.8 and ([Report].[Projected Used Capacity (GB)]/[Report].[Projected Capacity (GB)])&lt;1</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles><queries><query name="Report">

			<source>

				<model/>

			</source>

			<selection><dataItemMeasure name="Projected Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Capacity (GB)]</MUN><itemCaption>Projected Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Used Capacity (GB)]</MUN><itemCaption>Projected Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMemberProperty name="Month"><dmMemberProperty><MPUN>[Physical Capacity].[Date].[Date].[Month].[Month]</MPUN><itemCaption>Month</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel></dataItemMemberProperty><dataItemMeasure name="Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Capacity (GB)]</MUN><itemCaption>Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Used Capacity (GB)]</MUN><itemCaption>Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItem name="Date"><expression>CASE [Month]

WHEN 1 THEN 'Jan ' || [Year]

WHEN 2 THEN 'Feb '|| [Year]

WHEN 3 THEN 'Mar '|| [Year]

WHEN 4 THEN 'Apr '|| [Year]

WHEN 5 THEN 'May '|| [Year]

WHEN 6 THEN 'Jun '|| [Year]

WHEN 7 THEN 'Jul '|| [Year]

WHEN 8 THEN 'Aug '|| [Year]

WHEN 9 THEN 'Sep '|| [Year]

WHEN 10 THEN 'Oct '|| [Year]

WHEN 11 THEN 'Nov '|| [Year]

WHEN 12 THEN 'Dec '|| [Year]

END</expression></dataItem><dataItemMemberProperty name="Year"><dmMemberProperty><MPUN>[Physical Capacity].[Date].[Date].[Year].[Year]</MPUN><itemCaption>Year</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Year]</LUN><itemCaption>Year</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Storage Name"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Storage Name]</MPUN><itemCaption>Storage Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Model"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Model]</MPUN><itemCaption>Model</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Serial Number"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Serial Number]</MPUN><itemCaption>Serial Number</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Manufacturer"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Manufacturer].[Manufacturer]</MPUN><itemCaption>Manufacturer</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Manufacturer]</LUN><itemCaption>Manufacturer</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Data Center"><dmMemberProperty><MPUN>[Physical Capacity].[Data Center].[Data Center].[Data Center].[Data Center]</MPUN><itemCaption>Data Center</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Data Center]</DUN><itemCaption>Data Center</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Data Center].[Data Center]</HUN><itemCaption>Data Center</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Data Center].[Data Center].[Data Center]</LUN><itemCaption>Data Center</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Name"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Name]</MPUN><itemCaption>Tier Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Cost"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Cost]</MPUN><itemCaption>Tier Cost</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="Cost"><expression>[Tier Cost]</expression></dataItem><dataItemMeasure name="Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Raw Capacity (GB)]</MUN><itemCaption>Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Raw (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Used Raw Capacity (GB)]</MUN><itemCaption>Used Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Raw Capacity (GB)]</MUN><itemCaption>Projected Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Used Raw (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Used Raw Capacity (GB)]</MUN><itemCaption>Projected Used Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItem aggregate="total" name="Historical Cost"><expression>[Used Raw (GB)]*[Cost]</expression></dataItem><dataItem aggregate="total" name="Future Cost"><expression>[Projected Used Raw (GB)]*[Cost]</expression></dataItem><dataItem name="Total Cost of Storage"><expression>[Cost]*[Raw Capacity (GB)]</expression></dataItem></selection>

		</query><query name="sArray"><source><model/></source><selection><dataItemMemberProperty name="Storage Name"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Storage Name]</MPUN><itemCaption>Storage Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty></selection></query><query name="Latest Capacity">

			<source>

				

			<sqlQuery dataSource="dwh_capacity" name="SQL2">

			<sqlText>select `T0`.`C0` as "Data Center" , 

`T0`.`C1` as "Tier Name" , 

`T0`.`D1` as "Tier Cost" , 

`T0`.`C2` as "Storage Name" , 

`T0`.`C3` as "Vendor" , 

`T0`.`C4` as "Model" , 

`T0`.`B4` as "Serial Number" , 

`T0`.`C5` as "Storage Pool Name" , 

`T0`.`C6` as "is Thin Provisioning Supported?" , 

`T0`.`C7` as "Pool Type" , 

`T0`.`C8` as "Redundancy" , 

`T0`.`C9` as "Month" , 

`T0`.`B1` as "Full Date" , 

`T0`.`B2` as "isLatest?" , 

`T0`.`C10` as "capacity GB" , 

`T0`.`C12` as "usedCapacity GB" , 

`T0`.`C13` as "snapshotUsedCapacity GB" , 

`T0`.`C14` as "rawCapacity GB" , 

`T0`.`C15` as "usedRawCapacity GB" , 

`T0`.`C16` as "unconfiguredRawCapcity GB" , 

`T0`.`C17` as "failedRawCapacity GB" , 

`T0`.`C18` as "spareRawCapacity GB" , 

`T0`.`C19` as "volumeCapacity GB" , 

`T0`.`C20` as "unusedVolumeCapacity GB" , 

`T0`.`C21` as "Year" , 

`T0`.`C22` as "Quarter" , 

`T0`.`C23` as "MonthLabel" 



 from (

select `storage_dimension5`.`dataCenter` as "C0" , 

`tier_dimension`.`name` as "C1" , 

`tier_dimension`.`cost` as "D1" , 

`storage_dimension5`.`name` as "C2" , 

`storage_dimension5`.`manufacturer` as "C3" , 

`storage_dimension5`.`model` as "C4" , 

`storage_dimension5`.`serialnumber` as "B4" , 

`storage_pool_dimension`.`name` as "C5" , 

`storage_pool_dimension`.`thinProvisioningSupported` as "C6" , 

`storage_pool_dimension`.`type` as "C7" , 

`storage_pool_dimension`.`redundancy` as "C8" , 

`date_dimension`.`monthNum` as "C9" , 

`date_dimension`.`fulldate` as "B1" , 

`date_dimension`.`latest` as "B2" , 

sum(`coguda40`.`capacityMB` / 1048576) as "C10" , 

`date_dimension`.`tk` as "C11" , 

sum(`coguda40`.`usedCapacityMB` / 1048576) as "C12" , 

sum(`coguda40`.`snapshotUsedCapacityMB` / 1048576) as "C13" , 

sum(`coguda40`.`rawCapacityMB` / 1048576) as "C14" , 

sum(`coguda40`.`usedRawCapacityMB` / 1048576) as "C15" , 

sum(`coguda40`.`unconfiguredRawCapacityMB` / 1048576) as "C16" , 

sum(`coguda40`.`failedRawCapacityMB` / 1048576) as "C17" , 

sum(`coguda40`.`spareRawCapacityMB` / 1048576) as "C18" , 

sum(`coguda40`.`volumeCapacityMB` / 1048576) as "C19" , 

sum(`coguda40`.`unusedVolumeCapacityMB` / 1048576) as "C20" , 

`date_dimension`.`dateYear` as "C21" , 

`date_dimension`.`quarterLabel` as "C22" , 

`date_dimension`.`monthLabel` as "C23" 



from `storage_dimension` `storage_dimension5`, 

`tier_dimension` `tier_dimension`, 

`storage_pool_dimension` `storage_pool_dimension`, 

`date_dimension` `date_dimension`, 

`storage_and_storage_pool_capacity_fact` `coguda40`, 

`date_dimension` `coguda41`



where `coguda40`.`storageTk` = `storage_dimension5`.`tk` and `coguda40`.`storagePoolTk` = `storage_pool_dimension`.`tk` and `coguda40`.`dateTk` = `date_dimension`.`tk` and `tier_dimension`.`tk` = `coguda40`.`tierTk` and `coguda41`.`repMonthOrLatest` = 1 and `coguda40`.`virtual` = 0 and `coguda40`.`dateTk` = `coguda41`.`tk` and `storage_dimension5`.`tk` &lt;&gt; 0



group by `storage_dimension5`.`dataCenter`, `tier_dimension`.`name`, `storage_dimension5`.`name`, `storage_dimension5`.`manufacturer`, `storage_dimension5`.`model`, `storage_pool_dimension`.`name`, `storage_pool_dimension`.`thinProvisioningSupported`, `storage_pool_dimension`.`type`, `storage_pool_dimension`.`redundancy`, `date_dimension`.`monthNum`, `date_dimension`.`tk`, `date_dimension`.`dateYear`, `date_dimension`.`quarterLabel`, `date_dimension`.`monthLabel`) `T0`

</sqlText>

		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Tier Cost"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Storage Pool Name"/><mdProjectedItem name="is Thin Provisioning Supported?"/><mdProjectedItem name="Pool Type"/><mdProjectedItem name="Redundancy"/><mdProjectedItem name="Month"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="isLatest?"/><mdProjectedItem name="capacity GB"/><mdProjectedItem name="usedCapacity GB"/><mdProjectedItem name="snapshotUsedCapacity GB"/><mdProjectedItem name="rawCapacity GB"/><mdProjectedItem name="usedRawCapacity GB"/><mdProjectedItem name="unconfiguredRawCapcity GB"/><mdProjectedItem name="failedRawCapacity GB"/><mdProjectedItem name="spareRawCapacity GB"/><mdProjectedItem name="volumeCapacity GB"/><mdProjectedItem name="unusedVolumeCapacity GB"/><mdProjectedItem name="Year"/><mdProjectedItem name="Quarter"/><mdProjectedItem name="MonthLabel"/></mdProjectedItems></sqlQuery></source>

			<selection><dataItem name="Data Center"><expression>[SQL2].[Data Center]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL2].[Tier Name]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL2].[Serial Number]</expression></dataItem><dataItem name="Storage Pool Name"><expression>[SQL2].[Storage Pool Name]</expression></dataItem><dataItem name="is Thin Provisioning Supported?"><expression>[SQL2].[is Thin Provisioning Supported?]</expression></dataItem><dataItem name="Pool Type"><expression>[SQL2].[Pool Type]</expression></dataItem><dataItem name="Redundancy"><expression>[SQL2].[Redundancy]</expression></dataItem><dataItem name="Month"><expression>[SQL2].[Month]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="isLatest?"><expression>[SQL2].[isLatest?]</expression></dataItem><dataItem aggregate="total" name="capacity GB"><expression>[SQL2].[capacity GB]</expression></dataItem><dataItem aggregate="total" name="usedCapacity GB"><expression>[SQL2].[usedCapacity GB]</expression></dataItem><dataItem name="snapshotUsedCapacity GB"><expression>[SQL2].[snapshotUsedCapacity GB]</expression></dataItem><dataItem aggregate="total" name="rawCapacity GB"><expression>[SQL2].[rawCapacity GB]</expression></dataItem><dataItem name="usedRawCapacity GB"><expression>[SQL2].[usedRawCapacity GB]*1024</expression></dataItem><dataItem name="unconfiguredRawCapcity GB"><expression>[SQL2].[unconfiguredRawCapcity GB]</expression></dataItem><dataItem name="failedRawCapacity GB"><expression>[SQL2].[failedRawCapacity GB]</expression></dataItem><dataItem name="spareRawCapacity GB"><expression>[SQL2].[spareRawCapacity GB]</expression></dataItem><dataItem aggregate="total" name="volumeCapacity GB"><expression>[SQL2].[volumeCapacity GB]</expression></dataItem><dataItem name="unusedVolumeCapacity GB"><expression>[SQL2].[unusedVolumeCapacity GB]</expression></dataItem><dataItem name="Year"><expression>[SQL2].[Year]</expression></dataItem><dataItem name="Quarter"><expression>[SQL2].[Quarter]</expression></dataItem><dataItem name="MonthLabel"><expression>[SQL2].[MonthLabel]</expression></dataItem><dataItem name="% Used"><expression>[usedCapacity GB]/[capacity GB]</expression></dataItem><dataItemListSummary aggregateMethod="total" name="Total(rawCapacity GB)" refDataItem="rawCapacity GB"/><dataItemListSummary aggregateMethod="total" name="Total(capacity GB)" refDataItem="capacity GB"/><dataItem name="Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Total Storage Cost"><expression>[usedRawCapacity GB]*[Cost]</expression></dataItem></selection>

		<detailFilters><detailFilter><filterExpression>[isLatest?]=1</filterExpression></detailFilter></detailFilters></query><query name="Query1"><source><model/></source><selection/></query><query name="Latest">

			<source>

				<model/>

			</source>

			<selection><dataItemMeasure name="Projected Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Capacity (GB)]</MUN><itemCaption>Projected Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Used Capacity (GB)]</MUN><itemCaption>Projected Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Capacity (GB)]</MUN><itemCaption>Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Used Capacity (GB)]</MUN><itemCaption>Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMemberProperty name="Storage Name"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Storage Name]</MPUN><itemCaption>Storage Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Model"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Model]</MPUN><itemCaption>Model</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Serial Number"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Serial Number]</MPUN><itemCaption>Serial Number</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Manufacturer"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Manufacturer].[Manufacturer]</MPUN><itemCaption>Manufacturer</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Manufacturer]</LUN><itemCaption>Manufacturer</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Data Center"><dmMemberProperty><MPUN>[Physical Capacity].[Data Center].[Data Center].[Data Center].[Data Center]</MPUN><itemCaption>Data Center</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Data Center]</DUN><itemCaption>Data Center</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Data Center].[Data Center]</HUN><itemCaption>Data Center</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Data Center].[Data Center].[Data Center]</LUN><itemCaption>Data Center</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Name"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Name]</MPUN><itemCaption>Tier Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Cost"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Cost]</MPUN><itemCaption>Tier Cost</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="Cost / GB"><expression>[Tier Cost]</expression></dataItem><dataItemMeasure name="Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Raw Capacity (GB)]</MUN><itemCaption>Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Used Raw Capacity (GB)]</MUN><itemCaption>Used Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Raw Capacity (GB)]</MUN><itemCaption>Projected Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItem aggregate="total" name="Historical Cost"><expression>[Raw Capacity (GB)] * [Tier Cost]</expression></dataItem><dataItem name="Total Cost of Storage"><expression>[Cost / GB]*[Raw Capacity (GB)]</expression></dataItem><dataItemMemberProperty name="Full Date"><dmMemberProperty><MPUN>[Physical Capacity].[Date].[Date].[Month].[Full Date]</MPUN><itemCaption>Full Date</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel></dataItemMemberProperty></selection>

		<detailFilters><detailFilter><filterExpression>[Physical Capacity].[Latest Date]</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Arrays">

			<source>

				<model/>

			</source>

			<selection><dataItemMeasure name="Projected Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Capacity (GB)]</MUN><itemCaption>Projected Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Used Capacity (GB)]</MUN><itemCaption>Projected Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Capacity (GB)]</MUN><itemCaption>Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Used Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Used Capacity (GB)]</MUN><itemCaption>Used Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMemberProperty name="Storage Name"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Storage Name]</MPUN><itemCaption>Storage Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Model"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Model]</MPUN><itemCaption>Model</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Serial Number"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Storage].[Serial Number]</MPUN><itemCaption>Serial Number</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Storage]</LUN><itemCaption>Storage</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Manufacturer"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Manufacturer].[Manufacturer]</MPUN><itemCaption>Manufacturer</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Manufacturer]</LUN><itemCaption>Manufacturer</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Data Center"><dmMemberProperty><MPUN>[Physical Capacity].[Data Center].[Data Center].[Data Center].[Data Center]</MPUN><itemCaption>Data Center</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Data Center]</DUN><itemCaption>Data Center</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Data Center].[Data Center]</HUN><itemCaption>Data Center</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Data Center].[Data Center].[Data Center]</LUN><itemCaption>Data Center</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Name"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Name]</MPUN><itemCaption>Tier Name</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Cost"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Cost]</MPUN><itemCaption>Tier Cost</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="Cost"><expression>[Tier Cost]</expression></dataItem><dataItemMeasure name="Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Raw Capacity (GB)]</MUN><itemCaption>Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItemMeasure name="Projected Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Projected Capacity (GB)].[Projected Raw Capacity (GB)]</MUN><itemCaption>Projected Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Projected Capacity (GB)]</DUN><itemCaption>Projected Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItem aggregate="total" name="Total Cost of Storage"><expression>[Cost]*[Raw Capacity (GB)]</expression></dataItem><dataItemMemberProperty name="Full Date"><dmMemberProperty><MPUN>[Physical Capacity].[Date].[Date].[Month].[Full Date]</MPUN><itemCaption>Full Date</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="rank"><expression>rank([Total Cost of Storage])</expression></dataItem></selection>

		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;=5</filterExpression></detailFilter></detailFilters></query><query name="Top 5 Arrays1">

			<source>

				<model/>

			</source>

			<selection><dataItemMemberProperty name="Manufacturer"><dmMemberProperty><MPUN>[Physical Capacity].[Storage].[Storage].[Manufacturer].[Manufacturer]</MPUN><itemCaption>Manufacturer</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Storage]</DUN><itemCaption>Storage</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Storage].[Storage]</HUN><itemCaption>Storage</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Storage].[Storage].[Manufacturer]</LUN><itemCaption>Manufacturer</itemCaption></dmLevel></dataItemMemberProperty><dataItemMemberProperty name="Tier Cost"><dmMemberProperty><MPUN>[Physical Capacity].[Tier].[Tier].[Tier].[Tier Cost]</MPUN><itemCaption>Tier Cost</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Tier]</DUN><itemCaption>Tier</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Tier].[Tier]</HUN><itemCaption>Tier</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Tier].[Tier].[Tier]</LUN><itemCaption>Tier</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="Cost"><expression>[Tier Cost]</expression></dataItem><dataItemMeasure name="Raw Capacity (GB)"><dmMember><MUN>[Physical Capacity].[Capacity (GB)].[Raw Capacity (GB)]</MUN><itemCaption>Raw Capacity (GB)</itemCaption></dmMember><dmDimension><DUN>[Physical Capacity].[Capacity (GB)]</DUN><itemCaption>Capacity (GB)</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/></XMLAttributes></dataItemMeasure><dataItem aggregate="total" name="Total Cost of Storage"><expression>[Cost]*[Raw Capacity (GB)]</expression></dataItem><dataItemMemberProperty name="Full Date"><dmMemberProperty><MPUN>[Physical Capacity].[Date].[Date].[Month].[Full Date]</MPUN><itemCaption>Full Date</itemCaption></dmMemberProperty><dmDimension><DUN>[Physical Capacity].[Date]</DUN><itemCaption>Date</itemCaption></dmDimension><dmHierarchy><HUN>[Physical Capacity].[Date].[Date]</HUN><itemCaption>Date</itemCaption></dmHierarchy><dmLevel><LUN>[Physical Capacity].[Date].[Date].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel></dataItemMemberProperty><dataItem name="rank"><expression>rank([Total Cost of Storage])</expression></dataItem></selection>

		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;=5</filterExpression></detailFilter></detailFilters></query><query name="Capacity List Cost">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	dwh_capacity.storage_dimension.dataCenter AS 'Data Center',
	dwh_capacity.storage_dimension.name AS 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer AS 'Manufacturer',
	dwh_capacity.storage_dimension.model AS 'Model',
	dwh_capacity.storage_dimension.serialNumber AS 'Serial Number',
	dwh_capacity.tier_dimension.name AS 'Tier',
	dwh_capacity.tier_dimension.cost AS 'Cost / GB',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024, 2) AS 'Raw Capacity (GB)',
	ROUND((SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024) * dwh_capacity.tier_dimension.cost, 2) AS 'Total Cost of Storage'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
GROUP BY
	dwh_capacity.storage_dimension.tk,
	dwh_capacity.tier_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Cost / GB"/><mdProjectedItem name="Raw Capacity (GB)"/><mdProjectedItem name="Total Cost of Storage"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL1].[Serial Number]</expression></dataItem><dataItem name="Tier"><expression>[SQL1].[Tier]</expression></dataItem><dataItem name="Cost / GB"><expression>[SQL1].[Cost / GB]</expression></dataItem><dataItem name="Raw Capacity (GB)"><expression>[SQL1].[Raw Capacity (GB)]</expression></dataItem><dataItem name="Total Cost of Storage"><expression>[SQL1].[Total Cost of Storage]</expression></dataItem></selection>
		</query><query name="Base Forecast and Cost">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedrawcapacityMB)/1024/1024, 2) AS 'Raw Used Capacity (TB)',

	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Raw Used Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isvirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.name, dwh_capacity.date_dimension.fullDate
UNION
SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	NULL AS 'Raw Capacity (TB)',
	NULL AS 'Raw Used Capacity (TB)',
	NULL AS 'Capacity (TB)',
	NULL AS 'Used Capacity (TB)',
	NULL AS 'Provisioned (TB)',
	NULL AS 'Volume Consumed Capacity (TB)',
	NULL AS 'Internal Volume Allocated Capacity (TB)',
	NULL AS 'Internal Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawcapacityMB)/1024/1024, 2) AS 'Projected Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedrawcapacityMB)/1024/1024, 2) AS 'Projected Raw Used Capacity (TB)',

	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB)/1024/1024, 2) AS 'Projected Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB)/1024/1024, 2) AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_future_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.isvirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.name, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Raw Used Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Raw Used Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL3].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL3].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL3].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL3].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL3].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL3].[Cost]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL3].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Raw Used Capacity (TB)"><expression>[SQL3].[Raw Used Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)"><expression>[SQL3].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)"><expression>[SQL3].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL3].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL3].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL3].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL3].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL3].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Used Capacity (TB)"><expression>[SQL3].[Projected Raw Used Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL3].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)"><expression>[SQL3].[Projected Used Capacity (TB)]</expression></dataItem><dataItem name="Max Date"><expression>maximum([SQL3].[Full Date] for report)</expression></dataItem><dataItem name="Projected Cost" aggregate="total"><expression>IF([Full Date]=[Max Date]) THEN ((([Projected Raw Used Capacity (TB)]*1024)/1000/1000)*[Cost]) ELSE (0)</expression></dataItem></selection>
		</query><query name="Current Capacity">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedrawcapacityMB)/1024/1024, 2) AS 'Raw Used Capacity (TB)',

 ROUND(SUM(IF(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB &gt; dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB, dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB))/1024/1024, 0) AS volTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Raw Used Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
	
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isvirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
AND	dwh_capacity.storage_pool_dimension.name &lt;&gt; 'N/A'
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.tier_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Raw Used Capacity (TB)"/><mdProjectedItem name="volTB"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Raw Used Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL4].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL4].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL4].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL4].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL4].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL4].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL4].[Cost]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL4].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Raw Used Capacity (TB)"><expression>[SQL4].[Raw Used Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL4].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL4].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL4].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL4].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL4].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL4].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL4].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Used Capacity (TB)"><expression>[SQL4].[Projected Raw Used Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)"><expression>[SQL4].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)"><expression>[SQL4].[Projected Used Capacity (TB)]</expression></dataItem><dataItem name="Current Cost" aggregate="total"><expression>(([Raw Used Capacity (TB)]*1024)*[Cost])/1000/1000</expression></dataItem><dataItem name="volTB" aggregate="total"><expression>[SQL4].[volTB]</expression></dataItem></selection>
		</query></queries></report>